Searching is a core feature of Manticore Search. You can:

• Perform full-text search and implement search result highlighting
• Perform k-nearest neighbor search
• Apply non-full-text filtering
• Use expressions for filtering
• Utilize various search options
• Employ multi-queries and sub-selects
• Conduct aggregations and faceting of search results
• And much more

SQL:

SELECT
    select_expr [, select_expr] ...
    [FROM tbl_name
        [{INNER | LEFT} JOIN tbl2_name]
        [WHERE where_condition]
        [GROUP BY {col_name | expr}, ... ]
        [HAVING where_condition]
        [ORDER BY {col_name | expr}
            [ASC | DESC], ... ]
    ]
    [LIMIT {[offset,] row_count | row_count OFFSET offset}]
    [OPTION option1[, option2] ...]
    [FACET {expr_list} [BY {expr_list}] [DISTINCT {field_name}] [ORDER BY {expr | FACET()} {ASC | DESC}] [LIMIT [offset,] count]]

JSON:

POST /search
{   
    "table" : "table_name",
    "options":   
    {
      ...
    }
}